Location:
Search - excel ODBC
Search list
Description: 使用ODBC读取Excel文件中数据
Platform: |
Size: 19487 |
Author: |
Hits:
Description:
Platform: |
Size: 2284154 |
Author: |
Hits:
Description:
Platform: |
Size: 87225 |
Author: |
Hits:
Description: 用数据库读写方法，在VC中对EXCEL文件进行读写操作，包括DAO，ODBC等-database used to read and write, in the VC to Excel documents and write, including the DAO, ODBC, etc.
Platform: |
Size: 63393 |
Author: 任静 |
Hits:
Description: 一个把Excel文件当数据库使用的例子,可自动创建ODBC连接-an Excel document put to use when the database example, can automatically create ODBC link
Platform: |
Size: 525137 |
Author: 兰天 |
Hits:
Description: 1、上载文件说明:通过IIS中将TEST.ASP文件置为主页，然后就可在浏览器中访问（本机IP或者输入127.0.0.1)
2、使用说明：用记事本打开TEST.ASP，其中包含对SQL、ORADLE、ACCESS、ODBC数据源、EXCEL和TXT文本数据库的访问代码，对应去掉注释符号，并修改默认数据库名称和访问密码，保存并打开浏览器即可将访问到的数据显示出来。相当方便，提供数据库访问的代码，很难得的东东哦！
Platform: |
Size: 27883 |
Author: 宝柱 |
Hits:
Description: 数据快速导入到excel，速度特别快，比用odbc快100倍-rapid data import into excel, speed faster than 100 times faster odbc
Platform: |
Size: 306360 |
Author: my2006 |
Hits:
Description: 通过odbc操作数据库和excel对象的程序，我已经上传了5个了能不能通过呀，我需要这里的Modbus协议规范修改稿.zip文件-through odbc database and excel operation targeting procedures, I have uploaded the five can not passed it, I need here Modbus protocol specification Revised. zip file
Platform: |
Size: 204485 |
Author: sbl |
Hits:
Description: 这是一个利用ODBC访问EXCEL，并对其进行操作的例子-This is a use ODBC to access EXCEL, and examples of its operation
Platform: |
Size: 1995776 |
Author: |
Hits:
Description: ODBC实现对EXCEL的操作访问,实现了基本的功能-EXCEL ODBC operation to achieve access to basic functions implemented
Platform: |
Size: 4859904 |
Author: |
Hits:
Description: C++ odbc直接操作excel数据的详细步骤 -odbc operate excel database in c++
Platform: |
Size: 6144 |
Author: zl |
Hits:
Description: 使用vc++MFC的ODBC类，将Excel文件当作一般的数据库表格，利用ODBC技术像访问数据库一样去读／写Excel文
件。该文结合应用实例讨论了在Vc++程序中导出／导入Excel数据的方法。
注意：此文档非本人所写-Use vc++ MFC ODBC classes, the Excel file as a database form, the same as access to the database to read/write Excel files using ODBC technology. In this paper, combined with the application examples discussed in Vc++ program, export/import Excel data.
Note: This document is not written by me
Platform: |
Size: 520192 |
Author: 蓝锐 |
Hits:
Description: 软件包含了ODBC数据库操作演示，如何使用ODBC数据库创建EXCEL文件，使用.NET类库访问数据库以及DAO数据库的详细操作源码包括添加、删除、查找、字段操作-The software contains ODBC database operation demonstrates how to use the ODBC database to create the EXCEL file, use the NET class library to access the database as well as the detailed operation of the DAO database source including add, delete, search, field operations, etc.
Platform: |
Size: 3100672 |
Author: 李明 |
Hits:
Description: 本篇在某网友想使用Excel作数据源所作！其中大部分和《教你建立简单JDBC程序》基本一致，只有前面设置数据源部分有微小的差异，还有一个差异就是：程序中select的表名必须为[Sheet1$]格式，其中Sheet1是Excel中的页名。其它类似！-Benpian in some users want to use Excel as a data source made! Most of them and " teach you to create a simple JDBC program" basically the same, only the front part of setting up data sources differ slightly, there is a difference is this: the program select the table name must be [Sheet1 $] format, which is an Excel Sheet1 The page name. Other similar!
Platform: |
Size: 234496 |
Author: nick |
Hits:
Description:
One good thing about MS-Excel is it lets you add, delete, modify data in it programmatically. For this one needs to use ODBC or ADO. This chapter demonstrates how to use ODBC to stuff data into an Excel spreadsheet.-
One good thing about MS-Excel is it lets you add, delete, modify data in it programmatically. For this one needs to use ODBC or ADO. This chapter demonstrates how to use ODBC to stuff data into an Excel spreadsheet.
Platform: |
Size: 62464 |
Author: giri |
Hits:
Description: mfc读写excel的文档说明，通过ODBC来实现的。-mfc excel documents to read and write instructions, via ODBC to achieve.
Platform: |
Size: 15360 |
Author: zhang |
Hits:
Description: 直接通过ODBC读写Excel表格文件!!! !!! !!!!!1-Directly read and write Excel spreadsheet files through ODBC
Platform: |
Size: 2466816 |
Author: 肖湘 |
Hits:
Description: Ⅰ）将Excel97或Excel2000生成的XLS文件（book）看成一个数据库，其中的每一个工作表(sheet)看成数据库表
Ⅱ）ADO假设Excel中的第一行为字段名.所以你定义的范围中必须要包括第一行的内容
Ⅲ）Excel中的行标题（即字段名）不能够包含数字. Excel的驱动在遇到这种问题时就会出错的。例如你的行标题名为"F1"
Ⅳ）如果Excel表中某一列同时包含了文本和数字的话,那么Excel的ODBC驱动将不能够正常处理这一行的数据类型，你必须要保证该列的数据类型一致(加入预设符号强制转成文本，后台再作处理)
Ⅴ）日期型时，整列不能有空格，否则读不出- Ⅰ) will Excel97 or Excel2000 generated XLS file (book) as a database, where each worksheet (sheet) as a database table
Ⅱ) ADO assumption Excel field names in the first row, so you define the scope of the contents must include the first row
Ⅲ) Excel in a row heading (ie field names) can not contain numbers. Excel driver in the face of this problem will go wrong. For example, your line entitled "F1"
Ⅳ) If Excel table contains a column of text and numbers, then the Excel ODBC driver will not be able to properly handle this type of data rows, you must ensure that consistent data type of the column (added to the default symbol compulsory transfer into text, the background for further processing)
Ⅴ) Date type, the entire column can not have spaces, otherwise I can not reproduce
Platform: |
Size: 9216 |
Author: lintao |
Hits:
Description: VC++通过ODBC技术访问Excel时出现的问题及解决的方法和应用技巧-Appears when accessed via ODBC Excel VC++ technical problems and solutions, and application skills
Platform: |
Size: 276480 |
Author: dangdang |
Hits:
Description: JDBC-ODBC use Excel 操作Excel-JDBC-ODBC use Excel
Platform: |
Size: 234496 |
Author: gigi |
Hits: